package com.travel.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.travel.pojo.entity.ScenicSpot;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ScenicSpotMapper extends BaseMapper<ScenicSpot> {
    @Select("SELECT id, name, coordinates, opening_hours, location, " +
            "description, ticket_price, image_url, tags " +
            "FROM scenic_spots")
    List<ScenicSpot> selectAllWithoutCreatedAt();
}
